Things to Implement

Tables

• [x] esub_requests
• [x] esub_subscriptions

SQL Services

• [x] Service to delete any old esub_requests more than 2 weeks old that haven’t been opted in
• [x] Service to check for any opt-in emails that need to be sent
• [x] move subscription to member when email match

SQL Procedures/Functions

• [x] Create esub_request STP_WEB_CreateEsubRequest
• [x] Opt-in esub_request mc.GotOptIn
• [x] Search for email only users dbo.FCN_WEBCH_SearchEsubUsers
• [x] delete email only subscription dbo.STP_WEBCH_DeleteESub
• [x] Modify mailing STP to generate unsubscribe links for email only subscribers (mc.ProcessJobs)
• [x] Update unsubscribe service to handle email only subscribers (dbo.STP_WEB_DoUnsubscribe)
• [x] Update FCN to get Subscriptions for unsubscribe (dbo.WEB_GetSubscriptionsForUnsubscribe)

WebClient

• [x] Allow searching for email only members
• [x] Allow opening email only member
• [x] Allow deleting email only subscription
• [x] Allow sending esub request to email only member
• [x] Allow sending esub request to new email only subscriber
• [x] Allow sending esub request to full member
• [x] Remove email only subs from the Subscription Manager “to add” menu
• [x] Data Layer for SOAP services
• [x] Add Email only member to previous list
• [x] Add subscribed timestamp to email only member view

REST/SOAP services

• [x] Add Esub request
• [x] Opt in to esub request
• [x] Search for email
• [x] cancel esub subscription
• [x] Publish to SOAP
• [x] Get Email only Subscriptions
• [x] Add a REST subscribe endpoint https://soap.lcg.org/api/esub POST
• [x] Add a REST optin endpoint https://soap.lcg.org/api/esub/id/optin PUT

LCG Mailer

• [x] Import template from MailJet
• [x] Create a worst-case opt-in confirm page https://soap.lcg.org/optin/isoLang/id (or https://soap.lcg.org/optin/en/3C6C0A92-1EBD-4724-B292-AA8E39CD64FE for example)
• [x] Modify send code to handle Mailjet unsubscribe links
• [x] Per user MailJet api investigate

Subscriptions to migrate

• [x] ${Green("Australasian News Update (EANen)")}
• [x] ${Green("Canada Tomorrow’s World Presents (ECAen)")}
• [x] ${Green("To the Ends of the Earth (EEEen)")}
• [x] ${Green("Weekly Update (Spanish) (EWUes)")}
• [x] ${Green("UK Update - Monday (French) (EUMfr)")}
• [x] ${Green("UK Update - Friday (French) (EUFfr)")}
• [x] ${Green("UK Bible Study (English) (EUBen)")}
• [x] ${Green("UK Update - Monday (English) (EUMen)")}
• [x] ${Green("UK Update - Friday (English (EUFen)")}
• [x] ${Green("Tomorrow’s World Digital (ETWen)")}
• [x] ${Green("English Co-Worker Letter (ECLen)")}
• [x] ${Green("French Co-Worker Letter (ECLfr)")}

Stuff to remove when the ETWen migration is complete

1. SOAP endpoint at https://soap.lcg.org/WebDept/Service.asmx?op=ElectronicSubscriptionRequest
2. Stored procedure mc.ElectronicRequest
3. Stored procedure mc.SendOptInReminder
4. table mc.esub_requests
5. wc.UPLOAD_GetElectronicMatchSuggestions
6. wc.UPLOAD_GetUnprocessedOptIns
7. wc.UPLOAD_SetElectronicRequestStatus
8. wc.UPLOAD_UpdateMemberRecordFromElectronicRequest
9. wc.UPLOAD_NewRecordFromElectronic
10. Have already torn out the implementation in WebClient